package cn.hxth.cloud.consumer.mapper;


import cn.hxth.cloud.api.domain.Member;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface MemberMapper {
    @Select("SELECT mid,name,password,locked FROM member WHERE mid=#{value}")
	public Member findById(String id);
    @Insert("Insert into member(mid,password,name) Values(#{mid},#{password},#{name})")
    boolean doCreate(Member member);
   @Select("SELECT COUNT(mid) FROM member")
    Integer selectCount();
}
